UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+9L96lBz2ssxOzo1SfOtfyFLVNbT55mLlgzZ14bQz8s='
WHERE
key_id = '4183f504f5a417e2b14bbccd668426aabe97acd64327f5520cd934a5dfd4d224'
AND (
token = '+9L96lBz2ssxOzo1SfOtfyFLVNbT55mLlgzZ14bQz8s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)