UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kD1NynpXy2OFTRlQVBXFft8cpUVcsBUK/JAy7HBobxg='
WHERE
key_id = '3c54382f25f49354b7e5602028a497d88b634f8df983bf6b3b36c075690923f7'
AND (
token = 'kD1NynpXy2OFTRlQVBXFft8cpUVcsBUK/JAy7HBobxg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)