UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mXAiLcJ1SXGErWJvYmqzCql6Rpj8s+mMrjlzSM/vrT4='
WHERE
key_id = 'a92b9cda227e0455d4bffe1377b98ec636a8941307b9ec540353a246bdba5162'
AND (
token = 'mXAiLcJ1SXGErWJvYmqzCql6Rpj8s+mMrjlzSM/vrT4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)