UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XXO6F4NCpHz1DU7ycgtronIUnDL1MTzYp2UzNQhfvHA='
WHERE
key_id = '6382b4148dc8ea8aa63507beb67cedf40a057fa4e353521d3a69b34ebecc4d3c'
AND (
token = 'XXO6F4NCpHz1DU7ycgtronIUnDL1MTzYp2UzNQhfvHA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)