UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UCPZNdx3NNz+WKrtykL1zxZRLzbNWpnZP+ERhqR1SEQ='
WHERE
key_id = 'a4a459f1a564851781d4b6e6a31f00c4c9d6a846d8d4523b7704d0e7f0d71b14'
AND (
token = 'UCPZNdx3NNz+WKrtykL1zxZRLzbNWpnZP+ERhqR1SEQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)