UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vj6tj3VL7m78e2ffxf1OIthlE/L6iLFfvNqET9N8jjM='
WHERE
key_id = 'dca96d0becd50eafde3c45e92b514488be3682c6d45f086e4a9ce0a07b8a172f'
AND (
token = 'vj6tj3VL7m78e2ffxf1OIthlE/L6iLFfvNqET9N8jjM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)