UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ptfheVS4K5zJ6RtyfLsXfRzqYL+F72WtVH06DK9YwQ8='
WHERE
key_id = 'dbf92e84461587cc8070e86922fee0e9da6fc510e73da5a7c6472a8793847faf'
AND (
token = 'ptfheVS4K5zJ6RtyfLsXfRzqYL+F72WtVH06DK9YwQ8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)