UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'j1q1xptihYpUAFU3a05lJPxFcLTynZWlGMLLfmt5zP0='
WHERE
key_id = '34f7ff1fb98667f757b21cfe1dbc1a21789f9e67aefe5d3b99d188b997264e8a'
AND (
token = 'j1q1xptihYpUAFU3a05lJPxFcLTynZWlGMLLfmt5zP0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)