UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b1V2EI+aBj0WOHKksIG518fAWJaseI9R7bdX1umMHsY='
WHERE
key_id = '0d9f507cfc3fa4e51b5739f4b1e8ebf33a845194b142766792ef5f433a6fbce0'
AND (
token = 'b1V2EI+aBj0WOHKksIG518fAWJaseI9R7bdX1umMHsY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)