UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JLr0/3m37novwXiDgRtt0YpFdO1xj6gBmAqlI6dGeW4='
WHERE
key_id = 'cdfa1ca3b93087ce20a44e8a6f6b683c4ff3c609070d5f430e25ba7363364f4f'
AND (
token = 'JLr0/3m37novwXiDgRtt0YpFdO1xj6gBmAqlI6dGeW4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)