UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8ZSOph3Y52zqlfsnnC9MUZQO4E1W9h0rhqx1mrxi8OQ='
WHERE
key_id = '4b5433ef19289a068c539627284d3a655a44e30a3cd38037f1a6a9e27345000a'
AND (
token = '8ZSOph3Y52zqlfsnnC9MUZQO4E1W9h0rhqx1mrxi8OQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)