UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XKRRR7QxN+4yiZeEzNk+G16xB014IJr8vOy4BqKLVV0='
WHERE
key_id = 'e0d7f2dba08682340e3ab171e447b1a50c46f0cea5756932d5de9c0eafa09a53'
AND (
token = 'XKRRR7QxN+4yiZeEzNk+G16xB014IJr8vOy4BqKLVV0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)