UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W1qJI61EY/2mZ/mpNOfFFGPuIGx3/rB/rryzZVeZAg0='
WHERE
key_id = '31ec6692340c27a5b521f128df2b41f5a6458dfc12b0d85beb67c7fc0b9e215d'
AND (
token = 'W1qJI61EY/2mZ/mpNOfFFGPuIGx3/rB/rryzZVeZAg0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)