UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X0PAWy4ma0senOHd4sVjN1s32N8tjwQsAMyb7o/v9FQ='
WHERE
key_id = 'eed767568fbab012df6dddd56329cafbf53abea5df0b045d4b7cd2387ce89ba2'
AND (
token = 'X0PAWy4ma0senOHd4sVjN1s32N8tjwQsAMyb7o/v9FQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)