UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q4EWy5xSIx08QMJbPvyIrJD59KVfuK/S7lTjlsyROo4='
WHERE
key_id = '2dab468d515c37895b746dde8e9f630898dcbb15fb5f4690bfe160b1329fed68'
AND (
token = 'q4EWy5xSIx08QMJbPvyIrJD59KVfuK/S7lTjlsyROo4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)