UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LZ4tw3sB/O2dmpa/shGSRrm9I/KuTCWjVIIplSSmkxU='
WHERE
key_id = 'c4a421b30fb5e3b229e340782c52a978e5eed5bac235c5fc341ce4c2737b1ee3'
AND (
token = 'LZ4tw3sB/O2dmpa/shGSRrm9I/KuTCWjVIIplSSmkxU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)