UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D34WaiudXHPmNQCRPy0kjI1zt5nRQzeDrnxMIyJiR+I='
WHERE
key_id = '59545dc2fafb97162e62ec6e4ec02817a35360fc3a66a96df88be48e8d4ef4af'
AND (
token = 'D34WaiudXHPmNQCRPy0kjI1zt5nRQzeDrnxMIyJiR+I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)