UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mqGHKMqruBavSUIC04agccJPm7rJ27aJkwoeoscmvRE='
WHERE
key_id = '0be704884eb887686868b9c7d786a23941a69ac299ef1e3b4c2fe02dff232cb5'
AND (
token = 'mqGHKMqruBavSUIC04agccJPm7rJ27aJkwoeoscmvRE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)