UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bblsLKc2yOmFd7Nu7qOnwFMxS4cM/OSOmlZB4Et6dP4='
WHERE
key_id = 'e47943403649d20a050979f4149b6bccf7a83a6917cd93a088ba32c5d3cc3676'
AND (
token = 'bblsLKc2yOmFd7Nu7qOnwFMxS4cM/OSOmlZB4Et6dP4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)