UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XvoPzFCU8R+8PNRcbDFSPXxntdz1Rpc0T3Gwem+JswI='
WHERE
key_id = 'a4690ca1edb0f6eba5584c40f64817669e2f0047f0efdcbf9782c59ad5d4131f'
AND (
token = 'XvoPzFCU8R+8PNRcbDFSPXxntdz1Rpc0T3Gwem+JswI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)