UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BKGOSqvRTr7aKbonVNTe8KgBnBchnUNBAWD3IpjS5BE='
WHERE
key_id = '2b4e592b8d70593d3ff1a815eedc70ebe2606c5854934b275793d118d2ee22ba'
AND (
token = 'BKGOSqvRTr7aKbonVNTe8KgBnBchnUNBAWD3IpjS5BE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)