UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/bvayn9xlTu9IGxIkrYsOKsi3m7ysRkt83k/R7H9kCU='
WHERE
key_id = '5a1eef825b9f29001d22ef59dee90d3fe78648f9c05743fd44443320a9353de1'
AND (
token = '/bvayn9xlTu9IGxIkrYsOKsi3m7ysRkt83k/R7H9kCU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)