UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gqKcv0GbaHYLOF2d5UOJqB8HDv8cSdBAthiN8v8NtBo='
WHERE
key_id = '6be906825a82ea92717542204ee9e42177745bc361a77daadd5e06eb29d8d124'
AND (
token = 'gqKcv0GbaHYLOF2d5UOJqB8HDv8cSdBAthiN8v8NtBo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)