UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0NjCoDxRrYzNIFha6L0AJ7O0WTSotCiomW/mNYz+dkk='
WHERE
key_id = 'c8e51033f2a7cd8e95e0858c49da6e715fd4f9299566f3e5b6f89d0fc4ca71df'
AND (
token = '0NjCoDxRrYzNIFha6L0AJ7O0WTSotCiomW/mNYz+dkk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)