UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r2/oi+2edL/xjntsYjLNOOwJU9SBCLif7Pa5OcRQ3hs='
WHERE
key_id = '3c308ef2de6b176e9f460082f4cad41989c343b7743200ba1e45dc1843b14526'
AND (
token = 'r2/oi+2edL/xjntsYjLNOOwJU9SBCLif7Pa5OcRQ3hs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)