UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aBzq+vXbBYNlQKIJ/qUIHTAeG9v3djvPg1FpSxu5VVs='
WHERE
key_id = 'c1c9f45d7184ebb87250639e8c4a30fdf4d1f4280f905598219d75d97e95bb32'
AND (
token = 'aBzq+vXbBYNlQKIJ/qUIHTAeG9v3djvPg1FpSxu5VVs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)