UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z37ufHkd3Rvykcb0oGJrBW3qssICjcDdT7ZT4JLwY2U='
WHERE
key_id = '143d71993a998bc4b229459314bc5c699c6f6cd597316ef06ed91e752ed5f210'
AND (
token = 'Z37ufHkd3Rvykcb0oGJrBW3qssICjcDdT7ZT4JLwY2U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)