UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EJ4hWtGOj3jrD/9405vxi4hrRvHvAxy7LpQ/4qcnz8U='
WHERE
key_id = '6e5a4f93a24c41e866522a7cd3b5987bcef322d0cbd935be20f3d9320a309333'
AND (
token = 'EJ4hWtGOj3jrD/9405vxi4hrRvHvAxy7LpQ/4qcnz8U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)