UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hHZiAnjUWl6CMcw3QoLu7e6EBBoISeZkUV+hwjM8spk='
WHERE
key_id = '8048278ba43466869142483a428f8a1e7aa0962e6c265e44342a8dca2af70b89'
AND (
token = 'hHZiAnjUWl6CMcw3QoLu7e6EBBoISeZkUV+hwjM8spk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)