UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hQxpEmNKTE5L8otFG8r2sOEbXqd0XmF5Ivq5olezq+Y='
WHERE
key_id = 'a075291d5abce67247a8ee88dee5de29018f02a79aac79ad1d5a373e5e83ef1f'
AND (
token = 'hQxpEmNKTE5L8otFG8r2sOEbXqd0XmF5Ivq5olezq+Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)