UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gq5pHcYZ5K6pX+2ZJ8pOZkSpL4rTwiGCq4IzyZyBmpY='
WHERE
key_id = '8a31456ea6368d4c62d3bd01e7ea0904f1d3c05efe26c0d53bd352c7d662c240'
AND (
token = 'gq5pHcYZ5K6pX+2ZJ8pOZkSpL4rTwiGCq4IzyZyBmpY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)