UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6FGn4ynfiq+6TV/sRlgtaI9f7hB+u9qLqMEWPtOO9ro='
WHERE
key_id = '8d2a0c81578581d2db6a3005750a444e34293313a7654c0faaa9ec8157167f1e'
AND (
token = '6FGn4ynfiq+6TV/sRlgtaI9f7hB+u9qLqMEWPtOO9ro='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)