UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8Z6QSFIVX2hFui3bRly5JAx8REz6Q8fW6l/O9YotX0c='
WHERE
key_id = 'ae38ede765a555f1805d4bb29a29d5dfbd308a8ccfd58c9fbfcaf6ba0cd44a2a'
AND (
token = '8Z6QSFIVX2hFui3bRly5JAx8REz6Q8fW6l/O9YotX0c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)